Embedded Functional Dependencies and Data-completeness Tailored Database Design

We establish a principled schema design framework for data with missing values. The is based on the new notion of an embedded functional dependency, which independent interpretation values, able to express completeness and integrity requirements application data, capable capturing redundant value occurrences that may cause problems processing meets requirements. axiomatic, algorithmic, logical foundations reasoning about dependencies. These enable us introduce generalizations Boyce-Codd Third normal forms avoid difficulties any or minimize these across dependency-preserving decompositions, respectively. show how transform given into schemata meet requirements, conditions generalized forms. Data over those are therefore fit purpose by design. Extensive experiments benchmark illustrate effectiveness our acquisition constraints, process, performance designs in terms updates join queries.